DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50080} closed
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10003, pstmt-20031} clearParameters. 
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20032} Parameters : [cdb60d6e-2245-4c7f-ad83-cb0709981bf8]
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10004, pstmt-20033} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694, cdb60d6e-2245-4c7f-ad83-cb0709981bf8]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20032} Types : [VARCHAR]
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10004, pstmt-20033} Types : [VARCHAR, VARCHAR]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20032} executed. 1.9771 millis. SELECT c.competition_id competition_id, c.competition_time competition_time, c.competition_name
        competition_name,
        c.competition_content competition_content, c.competition_site competition_site, c.competition_state
        competition_state,
        c.competition_people_sum competition_people_sum, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_competition c
        LEFT JOIN t_file f
        ON c.competition_id = f.competition_id
        WHERE c.competition_id = ?
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10004, pstmt-20033} executed. 1.5736 millis. SELECT * FROM t_user_competition WHERE user_id = ? AND competition_id =
        ?
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50081} open
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10004, pstmt-20033, rs-50082} open
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50081} Header: [competition_id, competition_time, competition_name, competition_content, competition_site, competition_state, competition_people_sum, file_id, file_name, file_path]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10004, pstmt-20033, rs-50082} Header: [competition_id, user_id, date, win_ranking, win_level_name]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50081} Result: [cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2023 年 12 月 1 日, 书法大赛, 书法大赛将于最近举行，请大家踊跃报名, 广州软件学院, 1, 1, 42cd4e56-0c9f-479e-93a3-9871f5a25a86, 书法大赛须知.docx, C:\Users\Administrator\Desktop\file\notification\cdb60d6e-2245-4c7f-ad83-cb0709981bf8\书法大赛须知.docx]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10004, pstmt-20033, rs-50082} closed
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10004, pstmt-20033} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50081} closed
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20032} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20031} Parameters : [0]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20031} Types : [INTEGER]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20031} executed. 1.6577 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} open
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50083} closed
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20031} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20032} Parameters : [35054ded-b5d5-4b5e-951f-563855042fd6]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20032} Types : [VARCHAR]
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10004, pstmt-20036} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 5c027fa7-f93b-4e17-9584-2a3c5a83b694, 35054ded-b5d5-4b5e-951f-563855042fd6]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10004, pstmt-20036} Types : [VARCHAR, VARCHAR, VARCHAR]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20032} executed. 1.8644 millis. SELECT c.competition_id competition_id, c.competition_time competition_time, c.competition_name
        competition_name,
        c.competition_content competition_content, c.competition_site competition_site, c.competition_state
        competition_state,
        c.competition_people_sum competition_people_sum, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_competition c
        LEFT JOIN t_file f
        ON c.competition_id = f.competition_id
        WHERE c.competition_id = ?
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50084} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50084} Header: [competition_id, competition_time, competition_name, competition_content, competition_site, competition_state, competition_people_sum, file_id, file_name, file_path]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10004, pstmt-20036} executed. 1.4894 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state team_state,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name,
        u.user_id user_id
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        LEFT JOIN t_user_team ut
        ON t.team_id = ut.team_id
        LEFT JOIN t_user u
        ON t.captain_id = u.user_id
        WHERE (t.captain_id = ? OR ut.user_id = ?) AND
        t.competition_id = ?
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50084} Result: [35054ded-b5d5-4b5e-951f-563855042fd6, 2023 年 12 月 30 日, 王者荣耀大赛, 王者荣耀大赛需5人组队参加, 广州软件学院, 1, 5, null, null, null]
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10004, pstmt-20036, rs-50085} open
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10004, pstmt-20036, rs-50085} Header: [team_id, team_name, team_content, team_state, apply_time, team_content, competition_id, competition_name, user_id]
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10004, pstmt-20036, rs-50085} Result: [2910159a-4ecb-4836-8c93-95907e325a6f, test, test, 1, null, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 1]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50084} closed
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10004, pstmt-20036, rs-50085} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20032} clearParameters. 
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10004, pstmt-20036, rs-50085} closed
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10004, pstmt-20036} clearParameters. 
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20038} created. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20038} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20038} Types : [VARCHAR]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20038} executed. 1.8868 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50086} open
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50086} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50086} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50086} closed
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10004, pstmt-20038} clearParameters. 
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20038} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20038} Types : [VARCHAR]
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20038} executed. 1.1719 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50087} open
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50087} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50087} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50087} closed
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10004, pstmt-20038} clearParameters. 
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20038} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20038} Types : [VARCHAR]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20038} executed. 1.4536 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50088} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50088} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50088} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50088} closed
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10004, pstmt-20038} clearParameters. 
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10004, pstmt-20026} Parameters : [0]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10004, pstmt-20026} Types : [INTEGER]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10004, pstmt-20026} executed. 1.5641 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} open
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10004, pstmt-20026, rs-50089} closed
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10004, pstmt-20026} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20010} Parameters : []
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20010} Types : []
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20013} Parameters : []
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20013} Types : []
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20010} executed. 1.3277 millis. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} open
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Header: [competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Result: [35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Result: [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 5]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Result: [6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 3]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Result: [b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 3]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Result: [b7a13312-c532-4d01-9c16-2caa89491640, 人工智能大赛, 2]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} Result: [f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 3]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20013} executed. 2.0303 millis. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20010, rs-50090} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20006} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} open
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20006} Types : [VARCHAR]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20010} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Header: [user_id, user_name, email, password, name, phone, sex, user_className, period, role_id, role_name, college_id, college_name, university_id, university_name]
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [10, 20160216010, 19999999999@qq.com, 142d2175786b0a3e694d5230b8faebce, 赵一, 19999999999, 男, 计科3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [12, 20160216100, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20006} executed. 1.9323 millis. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50092} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50092} Header: [date, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50092} Result: [1718585969554, 辩论大赛, 知识竞赛, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 1, 1]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [15, 20160216105, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50092} Result: [1703122462137, 计算机组装大赛, 科技竞赛, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [16, 20160216106, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50092} Result: [1718641167555, test, 学科竞赛, f46a9634-77b6-43b0-8728-545bc84f0a95, 1, 1]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [17, 20160216107, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [18, 20160216108, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20006, rs-50092} closed
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [19, 20160216109, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20006} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [20, 20160216110, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20007} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [21, 20160216111, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20007} Types : [VARCHAR]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [21760cab-011c-435f-85cb-520adf25f7a9, 1, 123456789, 6932058980060f2c9130b59fd53b063b, 小狗, 123456789, 女, 软工四班, 2022, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [22, 20160216122, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [23, 20160216123, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [24, 20160216124, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [25, 20160216125, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [26, 20160216126, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [27, 20160216127, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20007} executed. 13.5552 millis. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [3, 20160216003, 12222222222@qq.com, bb3ff4cb46696769ac6d5585cf676dc9, 李四, 12222222222, 男, 计科（高博）3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20007, rs-50093} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [4, 20160216004, 13333333333@qq.com, 0bf9692378bc43a627c8f06d8cf0dc3f, 王五, 13333333333, 女, 计科2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20007, rs-50093} Header: [captain_id, apply_time, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [5, 20160216005, 14444444444@qq.com, 462ae56b5f766c9063d9485bab8af2e1, 赵六, 14444444444, 女, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20007, rs-50093} closed
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20007} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [6, 20160216006, 15555555555@qq.com, 31a56597d1cfa721c47f06b7aba8537b, 田七, 15555555555, 女, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [62714ebe-84b2-4280-987a-51dd805b4206, 12335564, null, 6203b523658908e9f2e8eae8227b1436, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [7, 20160216007, 16666666666@qq.com, 56c107fa559c745087bc7761825117cb, 王八, 16666666666, 女, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [8, 20160216008, 17777777777@qq.com, 43fcbe0f248a5d053bd3d2e25ceed982, 张四, 17777777777, 女, 计科（高博）2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [8c748c34-68ba-4ab6-bb4a-052111a4dd96, 2140707168, null, d5d470762c8fc9f3024d35574693ab5f, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [9, 20160216009, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, 陈六, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [9164b69d-b49e-468a-8f0c-bddfdfe896bf, 123456789123, null, 825ea423e9c0ad5cca03a6030b872e8e, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [9f14560c-4d1a-493f-8bd6-4d732d139db3, 2140707167, null, 2ffb196ba326771b64e836a249c18639, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [a098f98d-8eec-4885-9669-417bc0fbeff2, 2148, null, 8229bd86aab0b24e35c84da82e5c8ca4, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} Result: [d90b5e01-c706-442a-b1f5-8b2dff08a2ec, 2140129259, null, ccc4a79790646ca4e93898d6d05e8207, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10003, pstmt-20013, rs-50091} closed
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20013} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20039} created. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.team_content team_content, c.competition_id competition_id, c.competition_name competition_name
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        LEFT JOIN t_user_team ut
        ON t.team_id = ut.team_id
        WHERE ut.user_id = ? AND ut.user_id != t.captain_id
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20039} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20039} Types : [VARCHAR]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20039} executed. 1.4662 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.team_content team_content, c.competition_id competition_id, c.competition_name competition_name
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        LEFT JOIN t_user_team ut
        ON t.team_id = ut.team_id
        WHERE ut.user_id = ? AND ut.user_id != t.captain_id
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50094} open
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50094} Header: [team_id, team_name, team_content, team_state, team_headcount, team_content, competition_id, competition_name]
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50094} Result: [2910159a-4ecb-4836-8c93-95907e325a6f, test, test, 1, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛]
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50094} closed
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20039} clearParameters. 
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20040} created. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20040} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20040} Types : [VARCHAR]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20040} executed. 1.1481 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20040, rs-50095} open
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20040, rs-50095} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20040, rs-50095} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10003, pstmt-20040, rs-50095} closed
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10003, pstmt-20040} clearParameters. 
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10003, pstmt-20039} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10003, pstmt-20039} Types : [VARCHAR]
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10003, pstmt-20039} executed. 1.3198 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.team_content team_content, c.competition_id competition_id, c.competition_name competition_name
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        LEFT JOIN t_user_team ut
        ON t.team_id = ut.team_id
        WHERE ut.user_id = ? AND ut.user_id != t.captain_id
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50096} open
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50096} Header: [team_id, team_name, team_content, team_state, team_headcount, team_content, competition_id, competition_name]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50096} Result: [2910159a-4ecb-4836-8c93-95907e325a6f, test, test, 1, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10003, pstmt-20039, rs-50096} closed
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10003, pstmt-20039} clearParameters. 
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} Types : [VARCHAR]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} executed. 0.9794 millis. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50097} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50097} Header: [date, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50097} Result: [1718585969554, 辩论大赛, 知识竞赛, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 1, 1]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50097} Result: [1703122462137, 计算机组装大赛, 科技竞赛, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50097} Result: [1718641167555, test, 学科竞赛, f46a9634-77b6-43b0-8728-545bc84f0a95, 1, 1]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50097} closed
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20008} clearParameters. 
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} Types : [VARCHAR]
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} executed. 0.6515 millis. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50098} open
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50098} Header: [captain_id, apply_time, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-3 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50098} closed
DEBUG http-nio-8999-exec-3 druid.sql.Statement - {conn-10003, pstmt-20011} clearParameters. 
DEBUG http-nio-8999-exec-3 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20031} Parameters : [0]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20031} Types : [INTEGER]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20031} executed. 1.4403 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} open
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50099} closed
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20031} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20032} Parameters : [69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20028} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20032} Types : [VARCHAR]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20028} Types : [VARCHAR, VARCHAR]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20028} executed. 2.8153 millis. SELECT * FROM t_user_competition WHERE user_id = ? AND competition_id =
        ?
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20032} executed. 3.5288 millis. SELECT c.competition_id competition_id, c.competition_time competition_time, c.competition_name
        competition_name,
        c.competition_content competition_content, c.competition_site competition_site, c.competition_state
        competition_state,
        c.competition_people_sum competition_people_sum, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_competition c
        LEFT JOIN t_file f
        ON c.competition_id = f.competition_id
        WHERE c.competition_id = ?
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50100} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50101} open
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50100} Header: [competition_id, user_id, date, win_ranking, win_level_name]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50101} Header: [competition_id, competition_time, competition_name, competition_content, competition_site, competition_state, competition_people_sum, file_id, file_name, file_path]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50100} Result: [69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 5c027fa7-f93b-4e17-9584-2a3c5a83b694, 1703122462137, null, null]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50101} Result: [69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 2023 年12 月 23 日, 计算机组装大赛, 计算机组装大赛，分笔试和机试, 南硅谷A501, 1, 1, b652033f-adc0-4892-af9b-a5717ce5e9b6, 计算机组装大赛题型说明.docx, C:\Users\Administrator\Desktop\file\notification\69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2\计算机组装大赛题型说明.docx]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10005, pstmt-20028, rs-50100} closed
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50101} closed
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10005, pstmt-20028} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10003, pstmt-20032} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20041} created. DELETE FROM t_user_competition WHERE user_id = ? AND competition_id = ?
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20041} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20041} Types : [VARCHAR, VARCHAR]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20041} executed. 30.7923 millis. DELETE FROM t_user_competition WHERE user_id = ? AND competition_id = ?
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10003, pstmt-20041} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20042} created. INSERT INTO t_user_competition(competition_id, user_id, date) values (?,
        ?, ?)
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20042} Parameters : [69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 5c027fa7-f93b-4e17-9584-2a3c5a83b694, 1726146395109]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20042} Types : [VARCHAR, VARCHAR, BIGINT]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20042} executed. 14.5418 millis. INSERT INTO t_user_competition(competition_id, user_id, date) values (?,
        ?, ?)
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10003, pstmt-20042} clearParameters. 
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20031} Parameters : [0]
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20031} Types : [INTEGER]
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20031} executed. 1.9465 millis. SELECT n.notification_id notification_id,n.notification_state notification_state,n.notification_title
        notification_title, n.notification_time notification_time,
        c.competition_id competition_id, c.competition_level competition_level,c.competition_people_sum
        competition_people_sum,
        c.competition_type competition_type, c.competition_site competition_site,
        c.competition_state competitionState
        FROM t_notification n
        LEFT JOIN t_competition c
        ON n.competition_id = c.competition_id
        WHERE n.notification_type = ?
        ORDER BY n.notification_time DESC
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} open
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Header: [notification_id, notification_state, notification_title, notification_time, competition_id, competition_level, competition_people_sum, competition_type, competition_site, competition_state]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [bd3fa269-5f0c-4c82-b132-e41c1d085baa, 1, test, 1701253018247, f46a9634-77b6-43b0-8728-545bc84f0a95, 4, 1, 学科竞赛, 1, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [03fc898c-2b22-4a78-b2ee-8f044153d8bc, 0, 辩论大赛报名通知, 1701253011231, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [08875eac-80d2-4fdb-9aff-a4ee5c16b847, 1, 王者荣耀大赛报名通知, 1701252324521, 35054ded-b5d5-4b5e-951f-563855042fd6, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [5ef42dda-9912-4724-8c60-8a673023f3db, 1, 英雄联盟大赛报名, 1701235468745, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2, 5, 电子竞技, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [08db0bae-bfcf-4166-aa64-3c95f599dd66, 0, 生活知识竞赛通知, 1701112312456, 42b487e4-062b-4ca2-8585-925549b5ce87, 2, 1, 知识竞赛, 敷文园A101, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [592f5962-f0b3-4871-b3ee-44a4140e1e82, 1, 计算机组装大赛通知, 1700856542145, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1, 科技竞赛, 南硅谷A501, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [2d21f209-2cf5-4904-88cc-9d8b784fbf29, 1, 人工智能大赛即将开始, 1700698545632, b7a13312-c532-4d01-9c16-2caa89491640, 1, 2, 科技竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [a09ebd24-0f76-44bd-9942-62f6574fdf9c, 1, 软件设计大赛报名通知, 1590039041924, 975af2b6-34f8-448a-b343-f50c87ce2891, 2, 1, 学科竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [76b9685b-0776-4c63-b342-b2b240fc7a2e, 1, 英语知识竞赛通知, 1587307317325, f00c96b9-1528-47fe-97c0-505ce8452028, 2, 3, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [ce8a3c9c-12e7-4d90-a001-859fda283459, 1, 书法大赛报名通知, 1587304242710, cdb60d6e-2245-4c7f-ad83-cb0709981bf8, 2, 1, 知识竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [d489c052-604d-4df1-9800-d3bb27f8f64a, 1, 创新创业大赛广西区赛报名通知, 1587304109555, bc141f51-9677-4829-970f-4594540cdf3c, 3, 1, 创新创业, 广州大学, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [8a0fd983-0764-47e6-8d0e-9f01435e9e9b, 1, 羽毛球大赛报名通知, 1587297452968, b3aef8ae-0963-40ba-9f7e-769c750e613c, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [745760de-31d8-4d89-90c0-15e854b0978c, 1, 程序设计大赛报名通知, 1587297376834, eab19a30-3adc-4e74-baa9-bb74ecb558de, 1, 1, 科技竞赛, 南硅谷A, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [9b40c0cc-181e-4497-879f-51156511913f, 1, 数学建模大赛报名通知, 1587297306716, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 4, 3, 数学竞赛, 广州软件学院, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [bafa1f45-e1b5-4ec4-bff9-db053e64766b, 0, 兵乓球大赛报名通知, 1587297163228, ffe2ef61-69c1-4627-87eb-510948608f0d, 2, 1, 体育竞赛, 体育馆, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} Result: [ad6f3526-daad-4e06-aacd-385b0a57f6c6, 1, 英语口语大赛报名通知, 1587296943963, b2005d28-60a1-4387-9e28-7057c1885c70, 2, 3, 知识竞赛, 敷文园A501, 1]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10003, pstmt-20031, rs-50102} closed
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10003, pstmt-20031} clearParameters. 
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20032} Parameters : [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20032} Types : [VARCHAR]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20032} executed. 1.156 millis. SELECT c.competition_id competition_id, c.competition_time competition_time, c.competition_name
        competition_name,
        c.competition_content competition_content, c.competition_site competition_site, c.competition_state
        competition_state,
        c.competition_people_sum competition_people_sum, f.file_id file_id, f.file_name file_name, f.file_path file_path
        FROM t_competition c
        LEFT JOIN t_file f
        ON c.competition_id = f.competition_id
        WHERE c.competition_id = ?
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50103} open
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50103} Header: [competition_id, competition_time, competition_name, competition_content, competition_site, competition_state, competition_people_sum, file_id, file_name, file_path]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50103} Result: [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 2023 年 12 月 25 日, 英雄联盟大赛, 英雄联盟大赛, 广州软件学院, 1, 5, null, null, null]
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10003, pstmt-20032, rs-50103} closed
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10003, pstmt-20032} clearParameters. 
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20043} created. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state team_state,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name,
        u.user_id user_id
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        LEFT JOIN t_user_team ut
        ON t.team_id = ut.team_id
        LEFT JOIN t_user u
        ON t.captain_id = u.user_id
        WHERE (t.captain_id = ? OR ut.user_id = ?) AND
        t.competition_id = ?
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20043} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 5c027fa7-f93b-4e17-9584-2a3c5a83b694, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20043} Types : [VARCHAR, VARCHAR, VARCHAR]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20043} executed. 13.2115 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state team_state,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name,
        u.user_id user_id
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        LEFT JOIN t_user_team ut
        ON t.team_id = ut.team_id
        LEFT JOIN t_user u
        ON t.captain_id = u.user_id
        WHERE (t.captain_id = ? OR ut.user_id = ?) AND
        t.competition_id = ?
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20043, rs-50104} open
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20043, rs-50104} Header: [team_id, team_name, team_content, team_state, apply_time, team_content, competition_id, competition_name, user_id]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10005, pstmt-20043, rs-50104} closed
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10005, pstmt-20043} clearParameters. 
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20044} created. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20044} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20044} Types : [VARCHAR]
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20044} executed. 2.2824 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50105} open
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50105} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50105} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-7 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50105} closed
DEBUG http-nio-8999-exec-7 druid.sql.Statement - {conn-10005, pstmt-20044} clearParameters. 
DEBUG http-nio-8999-exec-7 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20044} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20044} Types : [VARCHAR]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20044} executed. 1.2587 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50106} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50106} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50106} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50106} closed
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10005, pstmt-20044} clearParameters. 
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10005, pstmt-20044} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10005, pstmt-20044} Types : [VARCHAR]
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10005, pstmt-20044} executed. 1.1945 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50107} open
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50107} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50107} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-10 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50107} closed
DEBUG http-nio-8999-exec-10 druid.sql.Statement - {conn-10005, pstmt-20044} clearParameters. 
DEBUG http-nio-8999-exec-10 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10005, pstmt-20044} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10005, pstmt-20044} Types : [VARCHAR]
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10005, pstmt-20044} executed. 1.0405 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50108} open
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50108} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50108} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-1 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50108} closed
DEBUG http-nio-8999-exec-1 druid.sql.Statement - {conn-10005, pstmt-20044} clearParameters. 
DEBUG http-nio-8999-exec-1 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10005, pstmt-20044} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10005, pstmt-20044} Types : [VARCHAR]
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10005, pstmt-20044} executed. 1.1853 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50109} open
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50109} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50109} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-5 druid.sql.ResultSet - {conn-10005, pstmt-20044, rs-50109} closed
DEBUG http-nio-8999-exec-5 druid.sql.Statement - {conn-10005, pstmt-20044} clearParameters. 
DEBUG http-nio-8999-exec-5 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10005} pool-connect
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10005, pstmt-20015} Parameters : []
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10005, pstmt-20015} Types : []
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10005, pstmt-20015} executed. 1.3639 millis. SELECT competition_id, competition_name, competition_people_sum
        FROM t_competition
        WHERE competition_people_sum > 1
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} open
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20008} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20008} Types : [VARCHAR]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Header: [competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Result: [35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Result: [4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 5]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Result: [6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 3]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Result: [b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 3]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Result: [b7a13312-c532-4d01-9c16-2caa89491640, 人工智能大赛, 2]
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} Result: [f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 3]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20008} executed. 1.0804 millis. SELECT uc.date dt, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state
        competition_state
        FROM t_user_competition uc
        LEFT JOIN t_competition c
        ON uc.competition_id = c.competition_id
        WHERE uc.user_id = ?
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-4 druid.sql.ResultSet - {conn-10005, pstmt-20015, rs-50110} closed
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} Parameters : []
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} Types : []
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50111} open
DEBUG http-nio-8999-exec-4 druid.sql.Statement - {conn-10005, pstmt-20015} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50111} Header: [date, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-4 druid.sql.Connection - {conn-10005} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50111} Result: [1718585969554, 辩论大赛, 知识竞赛, 1934a96c-9e6c-4863-b7fc-71e9156b19d5, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50111} Result: [1726146395109, 计算机组装大赛, 科技竞赛, 69c6b52d-3ceb-4b02-86f3-cbe5280c7cb2, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50111} Result: [1718641167555, test, 学科竞赛, f46a9634-77b6-43b0-8728-545bc84f0a95, 1, 1]
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20008, rs-50111} closed
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20008} clearParameters. 
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-connect
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20011} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20011} Types : [VARCHAR]
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20011} executed. 1.2398 millis. SELECT t.captain_id captain_id, t.apply_time apply_time, c.competition_name competition_name, c.competition_type competition_type,
        c.competition_id competition_id,c.competition_people_sum competition_people_sum, c.competition_state competition_state
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ? AND t.apply_time IS NOT NULL
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50112} open
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50112} Header: [captain_id, apply_time, competition_name, competition_type, competition_id, competition_people_sum, competition_state]
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} executed. 4.5968 millis. SELECT u.user_id user_id, u.user_name user_name, u.email email, u.password password, u.name name, u.phone phone,
        u.sex sex,u.user_className user_className, u.period period, r.role_id role_id, r.role_name role_name,
        c.college_id college_id,
        c.college_name college_name, un.university_id university_id, un.university_name university_name
        FROM t_user u
        LEFT JOIN t_user_role ur
        ON u.user_id = ur.user_id
        LEFT JOIN t_role r
        ON ur.role_id = r.role_id
        LEFT JOIN t_college c
        ON u.college_id = c.college_id
        LEFT JOIN t_university un
        ON c.university_id = un.university_id
DEBUG http-nio-8999-exec-6 druid.sql.ResultSet - {conn-10003, pstmt-20011, rs-50112} closed
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} open
DEBUG http-nio-8999-exec-6 druid.sql.Statement - {conn-10003, pstmt-20011} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Header: [user_id, user_name, email, password, name, phone, sex, user_className, period, role_id, role_name, college_id, college_name, university_id, university_name]
DEBUG http-nio-8999-exec-6 druid.sql.Connection - {conn-10003} pool-recycle
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [1, 2140707166, 1624588099@qq.com, 2ffb196ba326771b64e836a249c18639, 黄宏展, 13592817348, 男, 软工3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [10, 20160216010, 19999999999@qq.com, 142d2175786b0a3e694d5230b8faebce, 赵一, 19999999999, 男, 计科3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [11, 20160216011, 11111111111@qq.com, a96e2bcc3a9f83c0967621b669ea6f52, test, 11111111111, 男, 计科3班, null, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [12, 20160216100, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [13, 20160216101, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [14, 20160216104, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [15, 20160216105, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [16, 20160216106, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [17, 20160216107, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 会计学2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [18, 20160216108, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [19, 20160216109, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [2, 20160216002, 18888888888@qq.com, 5ef2015edb439cac2bea7c7bb3796eb1, 张三, 18888888888, 男, 计科4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [20, 20160216110, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [21, 20160216111, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [21760cab-011c-435f-85cb-520adf25f7a9, 1, 123456789, 6932058980060f2c9130b59fd53b063b, 小狗, 123456789, 女, 软工四班, 2022, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [22, 20160216122, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [23, 20160216123, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [24, 20160216124, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 通信1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [25, 20160216125, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [26, 20160216126, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [27, 20160216127, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, test, 11111111111, 男, 物联1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [3, 20160216003, 12222222222@qq.com, bb3ff4cb46696769ac6d5585cf676dc9, 李四, 12222222222, 男, 计科（高博）3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [4, 20160216004, 13333333333@qq.com, 0bf9692378bc43a627c8f06d8cf0dc3f, 王五, 13333333333, 女, 计科2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [5, 20160216005, 14444444444@qq.com, 462ae56b5f766c9063d9485bab8af2e1, 赵六, 14444444444, 女, 计科1班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [5c027fa7-f93b-4e17-9584-2a3c5a83b694, 2140129257, 1624588099@qq.com, 7e7212a5964e5098652d43a1fac1c39b, 黄宏展, 13592817348, 男, 软工3班, 21323, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [6, 20160216006, 15555555555@qq.com, 31a56597d1cfa721c47f06b7aba8537b, 田七, 15555555555, 女, 计科3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [62714ebe-84b2-4280-987a-51dd805b4206, 12335564, null, 6203b523658908e9f2e8eae8227b1436, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [7, 20160216007, 16666666666@qq.com, 56c107fa559c745087bc7761825117cb, 王八, 16666666666, 女, 物联3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [8, 20160216008, 17777777777@qq.com, 43fcbe0f248a5d053bd3d2e25ceed982, 张四, 17777777777, 女, 计科（高博）2班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [8c748c34-68ba-4ab6-bb4a-052111a4dd96, 2140707168, null, d5d470762c8fc9f3024d35574693ab5f, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [9, 20160216009, 11111111111@qq.com, 072e63c29a8e1044a0c959caf9357b63, 陈六, 11111111111, 男, 计科（高博）4班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [9164b69d-b49e-468a-8f0c-bddfdfe896bf, 123456789123, null, 825ea423e9c0ad5cca03a6030b872e8e, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [9f14560c-4d1a-493f-8bd6-4d732d139db3, 2140707167, null, 2ffb196ba326771b64e836a249c18639, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [a098f98d-8eec-4885-9669-417bc0fbeff2, 2148, null, 8229bd86aab0b24e35c84da82e5c8ca4, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 1, 管理员, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [b596a963-2b08-4c1c-95d4-02f9c3e9af30, 2140129270, 1624588099@qq.com, 404c937e029c884d87ae48e2fbb00d46, 戴嘉儒, 13592817348, 男, 软件工程3班, 2021, 3, 教师, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} Result: [d90b5e01-c706-442a-b1f5-8b2dff08a2ec, 2140129259, null, ccc4a79790646ca4e93898d6d05e8207, null, null, null, null, null, 2, 学生, 1, 广州软件学院, 1, 广州软件学院]
DEBUG http-nio-8999-exec-9 druid.sql.ResultSet - {conn-10004, pstmt-20020, rs-50113} closed
DEBUG http-nio-8999-exec-9 druid.sql.Statement - {conn-10004, pstmt-20020} clearParameters. 
DEBUG http-nio-8999-exec-9 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10004, pstmt-20038} Parameters : [5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10004, pstmt-20038} Types : [VARCHAR]
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10004, pstmt-20038} executed. 1.0182 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_content team_content, t.team_state
        team_state,t.team_headcount team_headcount,
        t.apply_time apply_time,t.team_content team_content, c.competition_id competition_id, c.competition_name
        competition_name, c.competition_people_sum competition_people_sum
        FROM t_team t
        LEFT JOIN t_competition c
        ON t.competition_id = c.competition_id
        WHERE t.captain_id = ?
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50114} open
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50114} Header: [team_id, team_name, team_content, team_state, team_headcount, apply_time, team_content, competition_id, competition_name, competition_people_sum]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50114} Result: [85a6312b-4ea0-449d-b5a0-71efc62d6584, da, w1, 1, 1, null, w1, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5]
DEBUG http-nio-8999-exec-8 druid.sql.ResultSet - {conn-10004, pstmt-20038, rs-50114} closed
DEBUG http-nio-8999-exec-8 druid.sql.Statement - {conn-10004, pstmt-20038} clearParameters. 
DEBUG http-nio-8999-exec-8 druid.sql.Connection - {conn-10004} pool-recycle
DEBUG http-nio-8999-exec-2 druid.sql.Connection - {conn-10004} pool-connect
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20022} Parameters : [1, 5c027fa7-f93b-4e17-9584-2a3c5a83b694]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20022} Types : [INTEGER, VARCHAR]
DEBUG http-nio-8999-exec-2 druid.sql.Statement - {conn-10004, pstmt-20022} executed. 1.4237 millis. SELECT t.team_id team_id, t.team_name team_name, t.team_headcount team_headcount, t.team_content team_content,
        c.competition_id competition_id, c.competition_name competition_name, u.user_id user_id, u.name name,
        u.phone phone, u.email email
        FROM t_team t
        LEFT JOIN t_competition c
        ON c.competition_id = t.competition_id
        LEFT JOIN t_user u
        ON u.user_id = t.captain_id
        WHERE t.team_state = ? AND t.captain_id != ?
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} open
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Header: [team_id, team_name, team_headcount, team_content, competition_id, competition_name, user_id, name, phone, email]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [17527ebf-6d41-44ed-869e-bd5650c08efc, 田七英雄队, 2, 田七英雄队等待加入, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 6, 田七, 15555555555, 15555555555@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [1bfc9d8a-7485-4319-85ac-ec074f6366fd, test, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 3, 李四, 12222222222, 12222222222@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [2910159a-4ecb-4836-8c93-95907e325a6f, test, 2, test, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 1, 黄宏展, 13592817348, 1624588099@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [2c19fdd2-a93d-457b-9b0b-764f234af7bc, 王五王者队, 1, 王五王者队, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [2d69c453-e7e4-444d-b806-57147cbc6e34, 口语赵六队, 1, 口语赵六队, b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [37731a17-b10f-41b4-8600-ad5acf5205df, 王五口语队, 1, 王五口语队, b2005d28-60a1-4387-9e28-7057c1885c70, 英语口语大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [72fd7591-87e5-411f-8b09-08bb34a26bac, 王五数模队, 1, 王五数模队招人, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 4, 王五, 13333333333, 13333333333@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [82ce95ce-a063-4835-9286-3c9cafea4270, 王者1队, 7, 等待广大玩家踊跃加入, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 2, 张三, 18888888888, 18888888888@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [99738531-a3c7-4378-9feb-7a676a4c69af, 数模赵六队, 2, 数模赵六队, 6c66cd4e-e980-44e4-a36f-fdbfe7552647, 数学建模大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [9f71a5d0-e1d3-4027-b542-6b5c2c75eca2, 赵一英雄联盟队, 1, 赵一英雄联盟队, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 10, 赵一, 19999999999, 19999999999@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [a9659f7f-81a2-4239-b4e1-a668408f8cd2, 王者赵六队, 2, 王者赵六队, 35054ded-b5d5-4b5e-951f-563855042fd6, 王者荣耀大赛, 5, 赵六, 14444444444, 14444444444@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [b4af2161-b5fe-4e33-b737-ed8761ea3c02, 张四联盟, 1, 张四联盟招人, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 8, 张四, 17777777777, 17777777777@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [b7996c26-bf12-409f-9347-d190f83f4c8d, 陈六联盟, 1, 陈六联盟, 4d25bdc3-d6e5-4066-a34d-ddd526bcf27d, 英雄联盟大赛, 9, 陈六, 11111111111, 11111111111@qq.com]
DEBUG http-nio-8999-exec-2 druid.sql.ResultSet - {conn-10004, pstmt-20022, rs-50115} Result: [c6202e86-0c86-4d8c-94b2-b837211badac, 赵六英语队, 1, 赵六英语队等待加入, f00c96b9-1528-47fe-97c0-505ce8452028, 英语知识竞赛, 5, 赵六, 14444444444, 14444444444@qq.com]
